<%@ page language="java" contentType="text/html; charset=UTF-8"    
    pageEncoding="UTF-8"%>
<%@ page import = "java.util.*" %>
<%@page import="demo.model.StudentInfo,demo.dal.Student"%>


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>学生信息查询</title>
</head>
<body>
	<table width="539" border="1">
		<tr>
			<td>学号</td>
			<td>姓名</td>
			<td>性别</td>
			<td>住址</td>
			<td>电话</td>
			<td>邮箱</td>
			<td>操作</td>
		</tr>
		<%
			Student sdb = new Student();
			String sql = "select * from student";
			List<Student> lst = sdb.getStudent(sql);
			for (Student stu : lst) {
				out.println("<tr><td>" + stu.getid() + "</td><td>" + stu.getSname() + "</td><td>" + stu.getSage() + "</td><td>" + stu.getSsex() + "</td><td>" + stu.getSnativeplace() + "</td><td>" + stu.getSmajor() + "</td><td>" + stu.getSclass() + "</td><td>" + stu.getSnative() + "</td></tr>");
			}
		%>

	</table>
</body>
</html>